/*
 Navicat Premium Data Transfer

 Source Server         : SMSDB
 Source Server Type    : SQLite
 Source Server Version : 3007003
 Source Database       : main

 Target Server Type    : SQLite
 Target Server Version : 3007003
 File Encoding         : utf-8

 Date: 08/13/2012 15:06:53 PM
*/

PRAGMA foreign_keys = false;

-- ----------------------------
--  Table structure for "smsserver_out"
-- ----------------------------
DROP TABLE IF EXISTS "smsserver_out";
CREATE TABLE "smsserver_out" (
	 "id" INTEGER PRIMARY KEY AUTOINCREMENT,
	 "type" varchar(1,0) NOT NULL DEFAULT 'O',
	 "recipient" varchar(16,0) NOT NULL,
	 "text" varchar(1000,0) NOT NULL,
	 "wap_url" varchar(100,0) DEFAULT NULL,
	 "wap_expiry_date" datetime DEFAULT NULL,
	 "wap_signal" varchar(1,0) DEFAULT NULL,
	 "create_date" datetime NOT NULL DEFAULT NULL,
	 "originator" varchar(16,0) NOT NULL DEFAULT ' ',
	 "encoding" varchar(1,0) NOT NULL DEFAULT '7',
	 "status_report" int(1,0) NOT NULL DEFAULT '1',
	 "flash_sms" int(1,0) NOT NULL DEFAULT '0',
	 "src_port" int(6,0) NOT NULL DEFAULT '-1',
	 "dst_port" int(6,0) NOT NULL DEFAULT '-1',
	 "sent_date" datetime DEFAULT NULL,
	 "ref_no" varchar(64,0) DEFAULT NULL,
	 "priority" int(5,0) NOT NULL DEFAULT '0',
	 "status" varchar(1,0) NOT NULL DEFAULT 'U',
	 "errors" int(2,0) NOT NULL DEFAULT '0',
	 "gateway_id" varchar(64,0) NOT NULL DEFAULT '*',
	 "modif_ref" varchar(64,0) DEFAULT NULL
);

-- ----------------------------
--  Records of "smsserver_out"
-- ----------------------------
BEGIN;
INSERT INTO "smsserver_out" VALUES ('1', 'O', '08563004073', 'asdasd', null, null, null, X'31333434383335303437363632', ' ', '7', '1', '0', '-1', '-1', X'31333434383335323936353831', '177', '0', 'D', '0', 'modem.com1', '1177');
INSERT INTO "smsserver_out" VALUES ('2', 'O', '08563004073', 'wwqjjasdas asdas', null, null, null, X'31333434383335303437363632', ' ', '7', '1', '0', '-1', '-1', X'31333434383430323938373030', '178', '0', 'D', '0', 'modem.com1', '2178');
COMMIT;

PRAGMA foreign_keys = true;
